https://store-images.s-microsoft.com/image/apps.36227.4d5e2acb-74a3-4158-a1b1-8beda21602f4.7f6f6421-2092-4565-a604-69c0256e845b.b845955d-8338-4492-a36d-a47fcba360c6

VisionOpenAPI

by Vision People A/S

Free trial badge

Retrieve data from any table. Very usefull in Business Intelligence

Read data from all tables in Business Central.

With VisionOpenAPI, you can retrieve all data from any table in Microsoft Dynamics 365 Business Central without the need for development.

VisionOpenAPI is a generic Page web service that can be used to extract data from any table and any field in Business Central, for example, for your Business Intelligence solution.

VisionOpenAPI works seamlessly with VisionPeople’s Power BI Package. While most users will use it in connection with our Power BI Package, VisionOpenAPI is also suitable for those developing their own data extraction solutions.

Features:

- Limit the number of fields extracted to only the necessary fields for optimized performance.

- Extract only changed data since a specific date stamp.

- Automatically include the systemId for related tables, which is particularly useful for model building in tools that do not allow multiple fields in the foreign keys, such as Power BI.

- Extract metadata for a table to retrieve field names, captions, and data types.

- Use paging through the OData prefer header: Prefer: odata.maxpagesize=300

At a glance

https://store-images.s-microsoft.com/image/apps.5238.4d5e2acb-74a3-4158-a1b1-8beda21602f4.7f6f6421-2092-4565-a604-69c0256e845b.d24ddcda-2d7a-4c97-b00b-17a211a5455f
https://store-images.s-microsoft.com/image/apps.33530.4d5e2acb-74a3-4158-a1b1-8beda21602f4.7f6f6421-2092-4565-a604-69c0256e845b.851b5653-11c4-4c0d-8fa8-4dca9f92d3e4
https://store-images.s-microsoft.com/image/apps.21686.4d5e2acb-74a3-4158-a1b1-8beda21602f4.7f6f6421-2092-4565-a604-69c0256e845b.7e3ba38d-5705-401a-93dd-96f0c8772384